**************************************************************************************************************************************************

* Zepeda Gil, Raúl "Adapted Picatto-Hidalgo-Lajous Mexico Historical XX Century Crime Rates Database for Decades Analysis" *
*** Zepeda Gil, Raúl, PhD Candidate, Defence Studies Department, King´s College London ***
*** email: zepeda.gil.raul@gmail.com / zepeda.raul@kcl.ac.uk ***


* + Original Database + *
**Piccato, P., Hidalgo, S., & Lajous, A. (2008). Estadísticas del crimen en México: Series Históricas 1926—2008. https://ppiccato.shinyapps.io/judiciales/**
**Lajous, A., & Piccato, P. (2018, April). Tendencias históricas del crimen en México. Nexos. https://www.nexos.com.mx/?p=36958**

* Adjecent to this Do-File, there is a PDF in wich I explain how the imputation and collapsing process by decades was made *

***************************************************************************************************************************************************

*** Replication File ***


**subtitute with your direction**
use "C:\xxx\DecadesCrimeRatesMexico.dta", clear 

** Declare panel **

 xtset entidad decade 

 
****** Key of variables ********

*** All data is for this periods 1950 - 60 - 70 - 80 - 90 - 00 - 05 
*** 32 Mexican States ***

* rate Homicide rates per state for decades 1950 to 2005 (Piccato, Hidalgo & Lajous 2017)

* escolaridad schooling rates in Mexican Censuses (INEGI)

* loggdp Logaritm of the GDP Per Capita (Carrion-I-Silvestre & German-Soto, 2007)

* logland Logaritm of land distributed in the National Agrarian Registry (RAN) (Albertus, 	et. al. 2016) 

* urban Percentage of urban population in Mexican Censuses (INEGI)

* water Percentafe of population with access to water in Mexican Censuses (INEGI) 

* youth Percentage of youth population share (under 29 years) 

* employment Percentage of available population employed in Mexican Censuses (INEGI) 

* hab Mean of inhabitants per household in Mexican Censuses (INEGI) 

* robbery Robbery rates (Piccato, Hidalgo & Lajous 2017)

* injuries Injuries crime rates (Piccato, Hidalgo & Lajous 2017)

* federaldrug Federal crime rates (Piccato, Hidalgo & Lajous 2017)

* smuggling Smuggling crime rates (Piccato, Hidalgo & Lajous 2017)

* propetydamage Propety damage crime rates (Piccato, Hidalgo & Lajous 2017)

* invlog Logaritm of social expenditure by state governments (UNDP, 2016) 

* party Party of the governor of the state. PRI is 1, Non PRI is 0, part of the term different parties is 0.5

* civilunion Percentage of population married in Mexican Censuses (INEGI) 


*** Data Sources ***

Albertus, M., Diaz-Cayeros, A., Magaloni, B., & Weingast, B. R. (2016). Authoritarian Survival and Poverty Traps: Land Reform in Mexico. World Development, 77, 154–170. https://doi.org/10.1016/j.worlddev.2015.08.013
Carrion-I-Silvestre, L. J., & German-Soto, V. (2007). Stochastic Convergence amongst Mexican States. Regional Studies, 41(4). https://doi.org/10.1080/00343400601120221
UNPD. (2016). Informe sobre Desarrollo Humano México 2016. Desigualdad y movilidad. United Nations Development Programme. 
	http://www.mx.undp.org/content/dam/mexico/docs/Publicaciones/PublicacionesReduccionPobreza/InformesDesarrolloHumano/idhmovilidadsocial2016/PNUD%20IDH2016.pdf
INEGI Censuses:
	1950: https://inegi.org.mx/programas/ccpv/1950/#Tabulados
	1960: https://inegi.org.mx/programas/ccpv/1960/
	1970: https://inegi.org.mx/programas/ccpv/1970/
	1980: https://inegi.org.mx/programas/ccpv/1980/
	1990: https://inegi.org.mx/programas/ccpv/1990/
	2000: https://inegi.org.mx/programas/ccpv/2000/
	2005: https://inegi.org.mx/programas/ccpv/2005/


